One of possible criteria is
o All member belonging to selected level
We will colorize members from level Product Family (Drink, Food, Non-Consumable) to yellow and then we
will drill all members from level Product Family to level Product Department with retaining
parents. This way
we will have members from different levels on the
table.
Rule:
Level of selected member will be
taken as condition.
To start colorizing:
·
select button Extended table
settings on tab Table
Dialog will appear:
·
select tab Row colors or Column colors (we will select Row colors)
·
select button Add to add members to be
colorized
Dialog that contains all member grouped by
hierarchies will appear:
Now make your choice:
·
uncheck Row Members box to deselect all
·
select Drink and Food
·
select OK
Now you are returned to previous dialog.
Selected Members are added to the table.
To add colors:
·
click on the cell for Fore color
or Back color (our case Back color
for Non-Consumable)
·
click on the button that appears inside
cell
·
select color
·
select OK
Selection will appear inside table:
·
select With condition cell to get
menu
·
select one of the options from
menu (we will select 5 – Level Unique
Name)
After selection there is no need to add any condition to cell Condition string.
Level of member Drink will be taken as
condition.
·
select OK
As you can entire table is yellow since Drink, Food and Non-Consumable belongs to same
level.
Now:
·
double click over any member from Product.hProduct
hierarchy
·
select DD Level (+)
it
will drill and RETAIN parents on the table